home *** CD-ROM | disk | FTP | other *** search
Text File | 2007-12-12 | 23.9 KB | 1,011 lines |
- object SyntAnal53: TLibSyntAnalyzer
- Formats = <
- item
- DisplayName = 'Default'
- Font.Charset = DEFAULT_CHARSET
- Font.Color = clWindowText
- Font.Height = -13
- Font.Name = 'Courier New'
- Font.Style = []
- FormatType = ftCustomFont
- end
- item
- DisplayName = 'Identifier'
- Font.Charset = DEFAULT_CHARSET
- Font.Color = clWindowText
- Font.Height = -13
- Font.Name = 'Courier New'
- Font.Style = []
- end
- item
- DisplayName = 'Reserved words MySQL '
- Font.Charset = DEFAULT_CHARSET
- Font.Color = clPurple
- Font.Height = -13
- Font.Name = 'Courier New'
- Font.Style = [fsBold]
- ChangeCase = ccUpper
- end
- item
- DisplayName = 'Reserved word'
- Font.Charset = DEFAULT_CHARSET
- Font.Color = clBlue
- Font.Height = -13
- Font.Name = 'Courier New'
- Font.Style = []
- ChangeCase = ccUpper
- end
- item
- DisplayName = 'Datatypes MySQL'
- Font.Charset = DEFAULT_CHARSET
- Font.Color = clWindowText
- Font.Height = -13
- Font.Name = 'Courier New'
- Font.Style = [fsBold]
- end
- item
- DisplayName = 'String'
- Font.Charset = DEFAULT_CHARSET
- Font.Color = clRed
- Font.Height = -13
- Font.Name = 'Courier New'
- Font.Style = []
- end
- item
- DisplayName = 'Comment'
- Font.Charset = DEFAULT_CHARSET
- Font.Color = clGreen
- Font.Height = -13
- Font.Name = 'Courier New'
- Font.Style = []
- end
- item
- DisplayName = 'Symbol'
- Font.Charset = DEFAULT_CHARSET
- Font.Color = clMaroon
- Font.Height = -13
- Font.Name = 'Courier New'
- Font.Style = []
- end
- item
- DisplayName = 'Number'
- Font.Charset = DEFAULT_CHARSET
- Font.Color = clOlive
- Font.Height = -13
- Font.Name = 'Courier New'
- Font.Style = []
- end
- item
- DisplayName = 'Marked block'
- Font.Charset = DEFAULT_CHARSET
- Font.Color = clHighlightText
- Font.Height = -13
- Font.Name = 'Courier New'
- Font.Style = []
- BgColor = clHighlight
- FormatType = ftColor
- end
- item
- DisplayName = 'Function'
- Font.Charset = DEFAULT_CHARSET
- Font.Color = clMaroon
- Font.Height = -13
- Font.Name = 'Courier New'
- Font.Style = []
- ChangeCase = ccUpper
- end
- item
- DisplayName = 'Table'
- Font.Charset = DEFAULT_CHARSET
- Font.Color = clGreen
- Font.Height = -13
- Font.Name = 'Courier New'
- Font.Style = []
- end
- item
- DisplayName = 'Alias'
- Font.Charset = DEFAULT_CHARSET
- Font.Color = clGreen
- Font.Height = -13
- Font.Name = 'Courier New'
- Font.Style = [fsBold]
- end
- item
- DisplayName = 'Operators'
- Font.Charset = DEFAULT_CHARSET
- Font.Color = clMaroon
- Font.Height = -13
- Font.Name = 'Courier New'
- Font.Style = [fsBold]
- end
- item
- DisplayName = 'Tree (Bold)'
- Font.Charset = DEFAULT_CHARSET
- Font.Color = clWindowText
- Font.Height = -13
- Font.Name = 'Courier New'
- Font.Style = []
- end
- item
- DisplayName = 'Tree (Section)'
- Font.Charset = DEFAULT_CHARSET
- Font.Color = clBlue
- Font.Height = -13
- Font.Name = 'Courier New'
- Font.Style = []
- end
- item
- DisplayName = 'Tree (item)'
- Font.Charset = DEFAULT_CHARSET
- Font.Color = clGreen
- Font.Height = -13
- Font.Name = 'Courier New'
- Font.Style = []
- end
- item
- DisplayName = 'Current Line'
- Font.Charset = DEFAULT_CHARSET
- Font.Color = clWindowText
- Font.Height = -13
- Font.Name = 'Courier New'
- Font.Style = []
- BgColor = 12570036
- FormatType = ftBackGround
- end
- item
- DisplayName = 'Datadictionary MySQL'
- Font.Charset = DEFAULT_CHARSET
- Font.Color = clFuchsia
- Font.Height = -13
- Font.Name = 'Courier New'
- Font.Style = [fsBold]
- end>
- TokenRules = <
- item
- DisplayName = 'String'
- StyleName = 'String'
- TokenType = 4
- Expression = '".*?("|$)'
- ColumnFrom = 0
- ColumnTo = 0
- end
- item
- DisplayName = 'String 2'
- StyleName = 'String'
- TokenType = 4
- Expression = #39'.*?('#39'|$)'
- ColumnFrom = 0
- ColumnTo = 0
- end
- item
- DisplayName = 'Any name'
- StyleName = 'Identifier'
- TokenType = 2
- Expression = '[a-z_]\w*'
- ColumnFrom = 0
- ColumnTo = 0
- end
- item
- DisplayName = 'Float'
- StyleName = 'Number'
- TokenType = 6
- Expression = '\d+\.?\d+e[\+\-]?\d+|\d+\.\d+'
- ColumnFrom = 0
- ColumnTo = 0
- end
- item
- DisplayName = 'Integer'
- StyleName = 'Number'
- TokenType = 5
- Expression = '\d+'
- ColumnFrom = 0
- ColumnTo = 0
- end
- item
- DisplayName = 'Comment'
- StyleName = 'Comment'
- TokenType = 1
- Expression = '(?s)/\*.*?(\*/|\Z)'#13#10
- ColumnFrom = 0
- ColumnTo = 0
- end
- item
- DisplayName = 'Comment 2'
- StyleName = 'Comment'
- TokenType = 1
- Expression = '--.*'
- ColumnFrom = 0
- ColumnTo = 0
- end
- item
- DisplayName = 'Comment 3'
- StyleName = 'Comment'
- TokenType = 1
- Expression = '\#.*'
- ColumnFrom = 0
- ColumnTo = 0
- end
- item
- DisplayName = 'Symbol'
- StyleName = 'Symbol'
- TokenType = 3
- Expression = '[/,\.;:\(\)=<>\+\-]+'
- ColumnFrom = 0
- ColumnTo = 0
- end>
- BlockRules = <
- item
- DisplayName = 'Key words'
- StyleName = 'Reserved word'
- BlockType = btTagDetect
- ConditionList = <
- item
- TagList.Strings = (
- 'create'
- 'delete'
- 'drop'
- 'from'
- 'group'
- 'having'
- 'insert'
- 'order'
- 'select'
- 'union'
- 'update'
- 'values'
- 'where')
- TokenTypes = 4
- IgnoreCase = True
- end>
- HighlightPos = cpAny
- TokenType = 10
- IgnoreAsParent = False
- end
- item
- DisplayName = 'Operations'
- StyleName = 'Operators'
- BlockType = btTagDetect
- ConditionList = <
- item
- TagList.Strings = (
- 'all'
- 'and'
- 'any'
- 'as'
- 'avg'
- 'between'
- 'by'
- 'count'
- 'distinct'
- 'exists'
- 'grant'
- 'in'
- 'index'
- 'inner'
- 'is'
- 'join'
- 'left'
- 'like'
- 'max'
- 'min'
- 'not'
- 'null'
- 'on'
- 'option'
- 'or'
- 'outer'
- 'some'
- 'table'
- 'view')
- TokenTypes = 4
- IgnoreCase = True
- end>
- HighlightPos = cpAny
- TokenType = 11
- IgnoreAsParent = False
- end
- item
- DisplayName = 'Functions'
- StyleName = 'Function'
- BlockType = btTagDetect
- ConditionList = <
- item
- TagList.Strings = (
- 'ASIN'
- 'ATAN'
- 'ATAN2'
- 'BENCHMARK'
- 'BIN'
- 'BINARY'
- 'BIT_AND'
- 'BIT_COUNT'
- 'BIT_LENGTH'
- 'BIT_OR'
- 'BIT_XOR'
- 'CAST'
- 'CEIL'
- 'CEILING'
- 'CHAR_LENGTH'
- 'CHARACTER_LENGTH'
- 'CHARSET'
- 'COALESCE'
- 'COERCIBILITY'
- 'COLLATION'
- 'COMPRESS'
- 'CONCAT'
- 'CONCAT_WS'
- 'CONNECTION_ID'
- 'CONV'
- 'CONVERT_TZ'
- 'COS'
- 'COT'
- 'CRC32'
- 'CURDATE'
- 'CURRENT_DATE'
- 'CURRENT_TIME'
- 'CURRENT_TIMESTAMP'
- 'CURRENT_USER'
- 'CURTIME'
- 'DATABASE'
- 'DATE'
- 'DATE_ADD'
- 'DATE_FORMAT'
- 'DATE_SUB'
- 'DATEDIFF'
- 'DAY'
- 'DAYNAME'
- 'DAYOFMONTH'
- 'DAYOFWEEK'
- 'DAYOFYEAR'
- 'DECODE'
- 'DEFAULT'
- 'DEGREES'
- 'DES_DECRYPT'
- 'DES_ENCRYPT'
- 'DIV'
- 'ELT'
- 'ENCODE'
- 'ENCRYPT'
- 'EXP'
- 'EXPORT_SET'
- 'EXTRACT'
- 'FIELD'
- 'FIND_IN_SET'
- 'FLOOR'
- 'FORMAT'
- 'FOUND_ROWS'
- 'FROM_DAYS'
- 'FROM_UNIXTIME'
- 'GET_FORMAT'
- 'GET_LOCK'
- 'GREATEST'
- 'GROUP_CONCAT'
- 'HEX'
- 'HOUR'
- 'IFNULL'
- 'INET_ATON'
- 'INET_NTOA'
- 'INSTR'
- 'INTERVAL'
- 'IS NULL'
- 'IS_FREE_LOCK'
- 'IS_USED_LOCK'
- 'ISNULL'
- 'LAST_DAY'
- 'LAST_INSERT_ID'
- 'LCASE'
- 'LEAST'
- 'LEFT'
- 'LENGTH'
- 'LOAD_FILE'
- 'LOCALTIME'
- 'LOCALTIMESTAMP'
- 'LOCATE'
- 'LOG'
- 'LOG10'
- 'LOG2'
- 'LPAD'
- 'LTRIM'
- 'MAKE_SET'
- 'MAKEDATE'
- 'MAKETIME'
- 'MASTER_POS_WAIT'
- 'MD5'
- 'MICROSECOND'
- 'MID'
- 'MINUTE'
- 'MOD'
- 'MONTH'
- 'MONTHNAME'
- 'NAME_CONST'
- 'OCT'
- 'OCTET_LENGTH'
- 'OLD_PASSWORD'
- 'PASSWORD'
- 'PERIOD_ADD'
- 'PERIOD_DIF'
- 'PI'
- 'POSITION'
- 'POW'
- 'POWER'
- 'QUARTER'
- 'QUOTE'
- 'RADIANS'
- 'RAND'
- 'REGEXP'
- 'RELEASE_LOCK'
- 'REPLACE'
- 'REVERSE'
- 'RIGHT'
- 'RLIKE'
- 'ROUND'
- 'ROW_COUNT'
- 'RPAD'
- 'RTRIM'
- 'SCHEMA'
- 'SEC_TO_TIME'
- 'SECOND'
- 'SESSION_USER'
- 'SHA1'
- 'SIGN'
- 'SIN'
- 'SLEEP'
- 'SOUNDEX'
- 'SOUNDS'
- 'SPACE'
- 'SQRT'
- 'STD'
- 'STDDEV'
- 'STDDEV_POP'
- 'STDDEV_SAMP'
- 'STR_TO_DATE'
- 'STRCMP'
- 'SUBDATE'
- 'SUBSTR'
- 'SUBSTRING'
- 'SUBSTRING_INDEX'
- 'SUBTIME'
- 'SYSTEM_USER'
- 'TAN'
- 'TIME'
- 'TIME_FORMAT'
- 'TIME_TO_SEC'
- 'TIMEDIFF'
- 'TIMESTAMP'
- 'TIMESTAMPADD'
- 'TIMESTAMPDIFF'
- 'TO_DAYS'
- 'TRIM'
- 'UCASE'
- 'UNCOMPRESS'
- 'UNCOMPRESSED_LENGTH'
- 'UNHEX'
- 'UNIX_TIMESTAMP'
- 'USER'
- 'UTC_DATE'
- 'UTC_TIME'
- 'UTC_TIMESTAMP'
- 'UUID'
- 'VAR_POP'
- 'VAR_SAMP'
- 'VARIANCE'
- 'WEEK'
- 'WEEKDAY'
- 'WEEKOFYEAR'
- 'XOR'
- 'YEAR'
- 'YEARWEEK')
- TokenTypes = 4
- IgnoreCase = True
- end>
- HighlightPos = cpAny
- TokenType = 11
- IgnoreAsParent = False
- end
- item
- DisplayName = 'MySQL Reserved words'
- StyleName = 'Reserved words MySQL '
- BlockType = btTagDetect
- ConditionList = <
- item
- TagList.Strings = (
- 'CHARACTER'
- 'COLLATION'
- 'COLUMNS'
- 'COMMIT'
- 'DESCRIBE'
- 'ENGINE'
- 'ENGINES'
- 'ERRORS'
- 'GRANTS'
- 'HELP'
- 'INNODB '
- 'LIMIT'
- 'LOGS'
- 'MUTEX'
- 'OPEN'
- 'PRIVILEGES'
- 'PROCESSLIST'
- 'PROFILE'
- 'PROFILES'
- 'RELEASE'
- 'ROLLBACK'
- 'SAVEPOINT'
- 'SHOW'
- 'START '
- 'STATUS'
- 'TRANSACTION '
- 'USE'
- 'VARIABLES')
- TokenTypes = 4
- IgnoreCase = True
- end>
- HighlightPos = cpAny
- TokenType = 11
- IgnoreAsParent = False
- end
- item
- DisplayName = 'MySQL datadictionary'
- StyleName = 'Datadictionary MySQL'
- BlockType = btTagDetect
- ConditionList = <
- item
- TagList.Strings = (
- 'CHARACTER_SETS'
- 'COLLATION_CHARACTER_SET_APPLICABILITY '
- 'COLLATIONS'
- 'COLUMN_PRIVILEGES'
- 'COLUMNS'
- 'columns_priv'
- 'db'
- 'func'
- 'help_category'
- 'help_keyword'
- 'help_relation'
- 'help_topic'
- 'host'
- 'KEY_COLUMN_USAGE'
- 'proc'
- 'procs_priv'
- 'ROUTINES'
- 'SCHEMA_PRIVILEGES'
- 'SCHEMATA'
- 'STATISTICS'
- 'TABLE_CONSTRAINTS'
- 'TABLE_PRIVILEGES'
- 'TABLES'
- 'Tables_in_information_schema'
- 'tables_priv'
- 'time_zone'
- 'time_zone_leap_second'
- 'time_zone_name'
- 'time_zone_transition'
- 'time_zone_transition_type'
- 'TRIGGERS'
- 'user'
- 'USER_PRIVILEGES'
- 'VIEWS')
- TokenTypes = 4
- IgnoreCase = True
- end>
- HighlightPos = cpAny
- TokenType = 11
- IgnoreAsParent = False
- end
- item
- DisplayName = 'MySQL datatypes'
- StyleName = 'Datatypes MySQL'
- BlockType = btTagDetect
- ConditionList = <
- item
- TagList.Strings = (
- 'BIGINT'
- 'BINARY'
- 'BLOB'
- 'CHAR'
- 'DATE'
- 'ENUM'
- 'INT'
- 'INYTEXT'
- 'LONGBLOB'
- 'LONGTEXT'
- 'MEDIUMBLOB'
- 'MEDIUMINT'
- 'MEDIUMTEXT'
- 'SET'
- 'SMALLINT'
- 'TEXT'
- 'TIME'
- 'TIMESTAMP'
- 'TINYBLOB'
- 'TINYINT'
- 'VARBINARY'
- 'VARCHAR'
- 'YEAR')
- TokenTypes = 4
- IgnoreCase = True
- end>
- HighlightPos = cpAny
- TokenType = 11
- IgnoreAsParent = False
- end
- item
- DisplayName = 'Table or Alias'
- StyleName = 'Table'
- BlockType = btTagDetect
- ConditionList = <
- item
- TagList.Strings = (
- '.')
- TokenTypes = 8
- end
- item
- TokenTypes = 4
- end>
- IdentIndex = 1
- HighlightPos = cpAny
- IgnoreAsParent = False
- end
- item
- DisplayName = 'Alias'
- StyleName = 'Alias'
- BlockName = 'From'
- BlockType = btTagDetect
- ConditionList = <
- item
- TokenTypes = 4
- end
- item
- TagList.Strings = (
- 'AS')
- TokenTypes = 2048
- IgnoreCase = True
- end>
- HighlightPos = cpAny
- TokenType = 8
- IgnoreAsParent = False
- end
- item
- DisplayName = 'Alias 2'
- BlockName = 'From'
- BlockType = btTagDetect
- ConditionList = <
- item
- TokenTypes = 4
- end
- item
- TokenTypes = 4
- end>
- HighlightPos = cpAny
- TokenType = 8
- IgnoreAsParent = False
- end
- item
- DisplayName = 'Table'
- StyleName = 'Table'
- BlockName = 'From'
- BlockType = btTagDetect
- ConditionList = <
- item
- TagList.Strings = (
- '.')
- CondType = tcNotEqual
- TokenTypes = 8
- end
- item
- TokenTypes = 4
- end>
- IdentIndex = 1
- HighlightPos = cpAny
- TokenType = 7
- IgnoreAsParent = False
- end
- item
- DisplayName = 'Table to Tree'
- BlockName = 'From'
- ConditionList = <
- item
- TokenTypes = 128
- end
- item
- TagList.Strings = (
- '.')
- CondType = tcNotEqual
- TokenTypes = 8
- end>
- BlockOffset = -1
- NotCollapsed = True
- GroupFmt = 'Used Tables'
- HighlightPos = cpAny
- NoEndRule = True
- TreeItemStyle = 'Tree (item)'
- TreeGroupStyle = 'Tree (Bold)'
- IgnoreAsParent = False
- end
- item
- DisplayName = 'Alias to tree'
- ConditionList = <
- item
- TokenTypes = 256
- end
- item
- CondType = tcNotEqual
- TokenTypes = 2048
- end>
- BlockOffset = 1
- NotCollapsed = True
- NameFmt = '%s-1 = %s0'
- GroupFmt = 'Aliases'
- HighlightPos = cpAny
- NoEndRule = True
- TreeItemStyle = 'Tree (item)'
- TreeGroupStyle = 'Tree (Bold)'
- TreeItemImage = 1
- IgnoreAsParent = False
- end
- item
- DisplayName = 'Alias to Tree 2'
- ConditionList = <
- item
- TokenTypes = 256
- end
- item
- TokenTypes = 2048
- end>
- NotCollapsed = True
- NameFmt = '%s-1 = %s0'
- GroupFmt = 'Aliases'
- HighlightPos = cpAny
- NoEndRule = True
- TreeItemStyle = 'Tree (item)'
- TreeGroupStyle = 'Tree (Bold)'
- TreeItemImage = 1
- IgnoreAsParent = False
- end
- item
- DisplayName = 'Statement start'
- ConditionList = <
- item
- TagList.Strings = (
- 'delete'
- 'insert'
- 'select'
- 'update')
- TokenTypes = 1024
- IgnoreCase = True
- end>
- EndOfTextClose = True
- HighlightPos = cpAny
- DrawStaple = True
- CollapseFmt = '%s0 ...'
- SelfClose = True
- TreeItemStyle = 'Tree (Bold)'
- TreeItemImage = 0
- IgnoreAsParent = False
- end
- item
- DisplayName = 'Section End'
- BlockType = btRangeEnd
- ConditionList = <
- item
- TokenTypes = 1024
- end>
- HighlightPos = cpAny
- IgnoreAsParent = False
- end
- item
- DisplayName = 'Database.Table to Tree'
- Enabled = False
- BlockName = 'From'
- ConditionList = <
- item
- TokenTypes = 132
- end
- item
- TagList.Strings = (
- '.')
- TokenTypes = 8
- end
- item
- TokenTypes = 4
- end>
- NotCollapsed = True
- NameFmt = '%s0.%s-2'
- GroupFmt = 'Used Tables'
- HighlightPos = cpAny
- CancelNextRules = True
- NoEndRule = True
- TreeItemStyle = 'Tree (item)'
- TreeGroupStyle = 'Tree (Bold)'
- TreeItemImage = 4
- IgnoreAsParent = False
- end
- item
- DisplayName = 'Select'
- ConditionList = <
- item
- TagList.Strings = (
- 'select')
- TokenTypes = 1024
- IgnoreCase = True
- end>
- BlockEnd = 'Section End'
- DisplayInTree = False
- HighlightPos = cpAny
- DrawStaple = True
- CollapseFmt = '%s0 ...'
- IgnoreAsParent = False
- end
- item
- DisplayName = 'From'
- ConditionList = <
- item
- TagList.Strings = (
- 'from')
- TokenTypes = 1024
- IgnoreCase = True
- end>
- BlockEnd = 'Section End'
- EndOfTextClose = True
- HighlightPos = cpAny
- DrawStaple = True
- CollapseFmt = '%s0 ...'
- TreeItemStyle = 'Tree (Section)'
- TreeItemImage = 2
- IgnoreAsParent = False
- end
- item
- DisplayName = 'Where'
- ConditionList = <
- item
- TagList.Strings = (
- 'where')
- TokenTypes = 1024
- IgnoreCase = True
- end>
- BlockEnd = 'Section End'
- EndOfTextClose = True
- HighlightPos = cpAny
- DrawStaple = True
- CollapseFmt = '%s0 ...'
- SelfClose = True
- TreeItemStyle = 'Tree (Section)'
- TreeItemImage = 2
- IgnoreAsParent = False
- end
- item
- DisplayName = 'Group'
- ConditionList = <
- item
- TagList.Strings = (
- 'group')
- TokenTypes = 1024
- IgnoreCase = True
- end>
- BlockEnd = 'Section End'
- EndOfTextClose = True
- HighlightPos = cpAny
- DrawStaple = True
- CollapseFmt = '%s0 ...'
- TreeItemStyle = 'Tree (Section)'
- IgnoreAsParent = False
- end
- item
- DisplayName = 'Order'
- ConditionList = <
- item
- TagList.Strings = (
- 'order')
- TokenTypes = 1024
- IgnoreCase = True
- end>
- EndOfTextClose = True
- HighlightPos = cpAny
- DrawStaple = True
- CollapseFmt = '%s0 ...'
- TreeItemStyle = 'Tree (Section)'
- TreeItemImage = 2
- IgnoreAsParent = False
- end
- item
- DisplayName = 'Having'
- ConditionList = <
- item
- TagList.Strings = (
- 'having')
- TokenTypes = 1024
- IgnoreCase = True
- end>
- EndOfTextClose = True
- HighlightPos = cpAny
- DrawStaple = True
- CollapseFmt = '%s0 ...'
- TreeItemStyle = 'Tree (Section)'
- TreeItemImage = 2
- IgnoreAsParent = False
- end
- item
- DisplayName = 'drop'
- ConditionList = <
- item
- TagList.Strings = (
- 'create'
- 'drop')
- TokenTypes = 1024
- IgnoreCase = True
- end>
- BlockEnd = 'drop end'
- EndOfTextClose = True
- HighlightPos = cpAny
- DrawStaple = True
- CollapseFmt = '%s0 ...'
- SelfClose = True
- TreeItemStyle = 'Tree (item)'
- IgnoreAsParent = False
- end
- item
- DisplayName = 'drop end'
- BlockType = btRangeEnd
- ConditionList = <
- item
- TagList.Strings = (
- ';')
- end>
- HighlightPos = cpAny
- IgnoreAsParent = False
- end>
- CodeTemplates = <>
- SubAnalyzers = <>
- SampleText.Strings = (
- ''
- 'SELECT c.session , c.username'
-
- 'FROM livehelp_domain_user a , livehelp_users b, livehelp_messag' +
- 'es c '
- 'WHERE a.id_domain = 29 AND'
- ' a.id_user = b.id AND '
- ' CONCAT(b.firstname, '#39' '#39',b.lastname) = c.username AND'
- ' DATE_FORMAT(c.datetime,'#39'%m/%Y'#39') ='#39'12/2006'#39
- 'GROUP BY c.session'
- 'ORDER BY c.session,c.username'
- ''
- '-- Duracion de las charlas por agente x dominio x mes'
- '-- parametros id_domain , mes'
- ''
-
- 'SELECT c.session , c.username , TIMEDIFF(max(c.datetime) , min(c' +
- '.datetime)) ,'
- ' DATE_FORMAT(c.datetime,'#39'%m/%d/%Y'#39')'
-
- 'FROM livehelp_domain_user a , livehelp_users b, livehelp_messag' +
- 'es c '
- 'WHERE a.id_domain = 29 AND'
- ' a.id_user = b.id AND '
- ' CONCAT(b.firstname, '#39' '#39',b.lastname) = c.username AND'
- ' DATE_FORMAT(c.datetime,'#39'%m%/%Y'#39') ='#39'09/2006'#39
- 'GROUP BY c.session'
- 'ORDER BY c.username'
- '')
- TokenTypeNames.Strings = (
- 'Unknown'
- 'Comment'
- 'Identifier'
- 'Symbol'
- 'String'
- 'Integer const'
- 'Float const'
- 'Table name'
- 'Alias'
- 'Function'
- 'Main KeyWords'
- 'Secondary KeyWords')
- MarkedBlockStyle = 'Marked block'
- DefaultStyleName = 'Default'
- Extentions = 'sql'
- LexerName = 'MySQL SQL'
- Internal = True
- LineComment = '--'
- Left = 144
- Top = 184
- end
-